/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50642
 Source Host           : localhost:3306
 Source Schema         : test

 Target Server Type    : MySQL
 Target Server Version : 50642
 File Encoding         : 65001

 Date: 28/05/2019 02:45:02
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `d_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `manager` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`d_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of department
-- ----------------------------
BEGIN;
INSERT INTO `department` VALUES (31, '人事部', '陶晨博', '管理人的地方');
INSERT INTO `department` VALUES (34, '技术部', 'ZZuisa', '好部门');
INSERT INTO `department` VALUES (36, '外联部', '汪弘扬', '这个好！');
INSERT INTO `department` VALUES (41, '财务部', '王浩润', '大老板');
INSERT INTO `department` VALUES (42, '市场部', '小兔兔', '这里是市场部~');
COMMIT;

-- ----------------------------
-- Table structure for face
-- ----------------------------
DROP TABLE IF EXISTS `face`;
CREATE TABLE `face` (
  `id` int(255) NOT NULL AUTO_INCREMENT,
  `recruit_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `edu` varchar(255) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  `cv` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of face
-- ----------------------------
BEGIN;
INSERT INTO `face` VALUES (2, 7, '123', '男', NULL, '专科生', NULL);
COMMIT;

-- ----------------------------
-- Table structure for person
-- ----------------------------
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `age` int(11) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `married` varchar(255) DEFAULT NULL,
  `idcard` varchar(255) DEFAULT NULL,
  `edu` varchar(255) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  `mobile` varchar(11) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `d_id` int(11) DEFAULT NULL,
  `org` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKranol98e1sc4ivux191hogiw5` (`d_id`) USING BTREE,
  CONSTRAINT `FKranol98e1sc4ivux191hogiw5` FOREIGN KEY (`d_id`) REFERENCES `department` (`d_id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of person
-- ----------------------------
BEGIN;
INSERT INTO `person` VALUES (29, 'hello', 18, '男', '未婚', '', '', '', '1', '323', '23', 31, '1');
INSERT INTO `person` VALUES (31, 'aa', 18, '男', '未婚', '', '', '', '11', '111', '11', 36, NULL);
INSERT INTO `person` VALUES (34, '王大力', 18, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '23@qq.com', 34, NULL);
INSERT INTO `person` VALUES (37, '汪宏扬', 18, '男', '已婚', '', '', '', '12221212', '2121212', '24880622283@qq.com', 34, NULL);
INSERT INTO `person` VALUES (39, '哈哈', 21, '男', '未婚', '', '', '', '12221212', '2121212', '2314139204367@qq.com', 31, NULL);
INSERT INTO `person` VALUES (40, '哈哈', 23, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '23@qq.com', 34, NULL);
INSERT INTO `person` VALUES (41, '哈哈', 18, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '23141394104367@qq.com', 34, NULL);
INSERT INTO `person` VALUES (42, '小兔兔', 24, '女', '已婚', NULL, NULL, NULL, '18638729339', NULL, '21016410239@qq.com', 42, NULL);
INSERT INTO `person` VALUES (43, '小王', 25, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '141390224367@qq.com', 34, NULL);
INSERT INTO `person` VALUES (46, '小张', 36, '男', '未婚', NULL, '本科生', NULL, '133', '12412', '141390433367@qq.com', 34, NULL);
INSERT INTO `person` VALUES (47, '旺达', 44, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '1413923204367@qq.com', 36, NULL);
INSERT INTO `person` VALUES (48, '丰富', 24, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '1413922304367@qq.com', 36, NULL);
INSERT INTO `person` VALUES (56, 'sck', 11, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '8372829165@qq.com', 36, NULL);
INSERT INTO `person` VALUES (57, 'hhq', 24, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '14139024367@qq.com', 34, NULL);
INSERT INTO `person` VALUES (58, '实时', 42, '男', '未婚', NULL, NULL, NULL, NULL, NULL, '141333904367@qq.com', 36, NULL);
INSERT INTO `person` VALUES (59, 'asd', 12, '男', '未婚', NULL, NULL, NULL, '14443535462', NULL, '837289165@qq.com', 34, NULL);
INSERT INTO `person` VALUES (60, '無雙', 78, '男', '未婚', '54654654656464', '博士生', '走着走着', '15616151615', '奥术大师大所大所', '11875623237691@qq.com', 41, NULL);
INSERT INTO `person` VALUES (62, '杨永信', 58, '男', '未婚', '411411444411441441', '博士生', '郑州大学', '18638729339', '郑州', '912672226583@qq.com', 41, NULL);
INSERT INTO `person` VALUES (63, 'qweqew', 17, '男', '未婚', '411414141414141414', '研究生', '郑州大学', '11111111111', '郑州', '912676223583@qq.com', 34, NULL);
INSERT INTO `person` VALUES (64, '权威', 24, '男', '未婚', '45654545645455', '博士生', '颠三倒四多', '16854165165', '大道瓦房店', '118756723691@qq.com', 31, NULL);
INSERT INTO `person` VALUES (65, '陶晨博', 21, '男', '未婚', '411411123423412313', '本科生', '郑州大学', '18638729339', '郑州', '91267236583@qq.com', 41, NULL);
INSERT INTO `person` VALUES (66, '王大力', 23, '男', '未婚', '411465199004562489', '博士生', '郑州大学', '18638729338', '河南省商丘市', '912676583@qq.com', 41, NULL);
INSERT INTO `person` VALUES (67, '王洪洋', 21, '男', '未婚', NULL, NULL, NULL, '18638234339', NULL, '110110110@qq.com', 42, NULL);
INSERT INTO `person` VALUES (69, 'wang', 24, '男', '未婚', '32422423412i44413', '专科生', '郑州二十六中', '123132222', '地球村', '2488062283@qq.com', 42, NULL);
INSERT INTO `person` VALUES (70, '44', 32, '女', '已婚', '442143124124124', '中专', '214', '12344444444', '4421', '213@qq.com', NULL, '3');
INSERT INTO `person` VALUES (71, 'rr', 33, '女', '已婚', '442143124124124', '高中', '333', '12412444332', '14124', '572220216@qq.com', NULL, '2');
COMMIT;

-- ----------------------------
-- Table structure for recruit
-- ----------------------------
DROP TABLE IF EXISTS `recruit`;
CREATE TABLE `recruit` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `filepath` varchar(255) DEFAULT NULL,
  `state` int(11) DEFAULT NULL,
  `email` varchar(128) DEFAULT NULL,
  `cv` varchar(255) DEFAULT NULL,
  `edu` varchar(255) DEFAULT NULL,
  `pass` int(255) DEFAULT '0',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of recruit
-- ----------------------------
BEGIN;
INSERT INTO `recruit` VALUES (25, '小张', '本科生', '男', 's\'s', 2, '2333@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (26, '旺达', '研究生', '男', 'sd2e1', 2, '141393304367@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (27, '丰富', '本科生', '男', '12的', 2, '1413904367@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (28, 'sck', '研究生', '男', 'hhh\n', 2, '8372289165@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (29, 'hhq', '研究生', '男', 'hhh\n', 2, '141390334367@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (30, '实时', '研究生', '男', 'hhh\n', 2, '141393304367@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (31, 'asd', '博士生', '男', '哈哈哈', 2, '837289165@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (32, 'asd', '博士生', '男', '哈哈哈', 2, '1413904367@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (33, '無雙', '本科生', '男', '我很厉害呀', 2, '11875627691@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (34, '陶晨博', '本科生', '男', '我是本科生', 2, '9126276583@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (35, '陶晨博', '博士生', '男', '我是boshishebg', -2, '9126736583@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (36, 'qweqew', '本科生', '男', 'hahahaha', 2, '912676583@qq.com', NULL, NULL, 0);
INSERT INTO `recruit` VALUES (37, '权威', '博士生', '男', '驱蚊器翁群翁群', 2, '1187567691@qq.com', NULL, NULL, 0);
COMMIT;

-- ----------------------------
-- Table structure for salary
-- ----------------------------
DROP TABLE IF EXISTS `salary`;
CREATE TABLE `salary` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `salary` varchar(255) DEFAULT NULL,
  `bonus` double(11,0) DEFAULT '0',
  `e_id` int(11) DEFAULT NULL,
  `fine` double(255,0) DEFAULT '0',
  `level` int(255) DEFAULT '1',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE KEY `UK_e6jtpyx6nak5hwa11kh1gohdh` (`e_id`) USING BTREE,
  CONSTRAINT `FKghk70bv5i6yhyyxf0g7qbuemm` FOREIGN KEY (`e_id`) REFERENCES `person` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of salary
-- ----------------------------
BEGIN;
INSERT INTO `salary` VALUES (1, '汪宏扬', '101250.000000000', 900, NULL, 600, 5);
INSERT INTO `salary` VALUES (2, '123', '20000', 0, NULL, 0, 1);
INSERT INTO `salary` VALUES (3, '哈哈', '22000', 2000, 40, 0, 1);
INSERT INTO `salary` VALUES (11, '小芳', '18010', 16000, 42, 0, 1);
INSERT INTO `salary` VALUES (12, '小王', '202002', 2000, 43, 0, 1);
INSERT INTO `salary` VALUES (14, '小张', '2010', 0, 46, 0, 1);
INSERT INTO `salary` VALUES (15, '旺达', '20000', 0, 47, 0, 1);
INSERT INTO `salary` VALUES (16, '丰富', '20000', 0, 48, 0, 1);
INSERT INTO `salary` VALUES (17, 'sck', '26000', 6000, 56, 0, 1);
INSERT INTO `salary` VALUES (18, 'hhq', '20000', 0, 57, 0, 1);
INSERT INTO `salary` VALUES (19, '实时', '30000', 10000, 58, 0, 1);
INSERT INTO `salary` VALUES (20, 'asd', '20000', 0, 59, 0, 1);
INSERT INTO `salary` VALUES (24, '無雙', '112000', 92000, 60, 0, 1);
INSERT INTO `salary` VALUES (26, '陶晨博', '36000', 16000, 62, 0, 1);
INSERT INTO `salary` VALUES (27, 'qweqew', '22000', 2000, 63, 0, 1);
INSERT INTO `salary` VALUES (28, '权威', '22000', 2000, 64, 0, 1);
INSERT INTO `salary` VALUES (29, '陶晨博', '20000', 0, 65, 0, 1);
INSERT INTO `salary` VALUES (30, '陶晨博', '20000', 0, 66, 0, 1);
INSERT INTO `salary` VALUES (31, '王洪洋', '20000', 0, 67, 0, 1);
INSERT INTO `salary` VALUES (33, 'wang', '20000', 0, 69, 0, 1);
INSERT INTO `salary` VALUES (34, '44', '3000', 0, NULL, 0, 1);
INSERT INTO `salary` VALUES (35, 'rr', '3000', 0, NULL, 0, 1);
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `role` varchar(255) DEFAULT '1',
  `code` varchar(255) DEFAULT NULL,
  `state` varchar(2) DEFAULT '0',
  `account` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `major` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=79 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` VALUES (1, 'admin', '123', '1', '3', 'ACTIVED', '1', NULL, NULL, NULL);
INSERT INTO `user` VALUES (2, 'zgf', '123', '1', '3', 'ACTIVED', '1', NULL, NULL, NULL);
INSERT INTO `user` VALUES (23, 'zgff', 'asdasdasd', '1', '1', '21e325aef23848d997e84ceb0540c2086b7e724727874263b159361203209845', '0', NULL, NULL, NULL);
INSERT INTO `user` VALUES (24, 'zgfff', '123123123', '2', '1', '0e87d47938f5484c9e2c86b8545570d6281227ad22d84cebaeac2afafe6052c5', '0', NULL, NULL, NULL);
INSERT INTO `user` VALUES (25, 'zgfffr', 'asdasdasd', '3', '1', 'ACTIVED', '1', NULL, NULL, NULL);
INSERT INTO `user` VALUES (26, 'zzhh', 'sa123123', '4', '1', '6f2fbc3f7f5a40c59c6d72ab69919c2d17b053bc43e14163a5ad80b400c16442', '0', NULL, NULL, NULL);
INSERT INTO `user` VALUES (27, 'aa123', 'sa123123', '5', '1', 'ACTIVED', '1', NULL, NULL, NULL);
INSERT INTO `user` VALUES (28, 'zcza', 'zcsc751023', 'zcga110@163.com', '1', 'ACTIVED', '1', NULL, NULL, NULL);
INSERT INTO `user` VALUES (29, 'ss44', 'asdasdasd', '6', '1', 'cdac772bf3e04bc58ddaa244c41f3fce1af99de1b889414c8ad508bd8042f1d7', '0', NULL, NULL, NULL);
INSERT INTO `user` VALUES (30, 'aaa23', 'asdasdasd', '1111@qq.com', '1', 'b067d0a5177a4aa6963b68d3bfd22f97a9a0920761e04a7bb527fe046a17423c', '0', NULL, NULL, NULL);
INSERT INTO `user` VALUES (31, 'aaa2344', 'asdasdasd', '7', '1', 'ACTIVED', '1', NULL, NULL, NULL);
INSERT INTO `user` VALUES (32, 'aaa234412', 'qweqweqwe', '8', '1', 'ACTIVED', '1', NULL, NULL, NULL);
INSERT INTO `user` VALUES (35, 'asdqq', 'asdasdasd', '2', '1', '74b19fe978554dc5819b2f7301465df3b96c368aa92943d283174aa962d5e11f', '0', NULL, NULL, NULL);
INSERT INTO `user` VALUES (36, 'ffqq', 'asdasdasd', '2', '1', '9ef5f15e253d4c7e8406a9abad0ae327dd39d0a2f9b349ffb92966d4c6885945', '0', NULL, NULL, NULL);
INSERT INTO `user` VALUES (38, '王大力', 'asdasdasd', '22@qq.com', '1', '70fbe31a29904aa18551784e554ceded7959963fa7d54eae8e377957ee2d7850', '1', '王大力', NULL, NULL);
INSERT INTO `user` VALUES (39, 'wangdali', 'asdasdasd', '3', '1', '619adb0118ab48d4bd0e3816cc47646c8bde4b877e654e96b34e7f0eac22c1eb', '0', '', NULL, NULL);
INSERT INTO `user` VALUES (41, '12334dd', 'asdasdasd', '2314132204367@qq.com', '1', '41de71639c7449e9883c46bf6bd225d33e927b340e89416ab5a28beedf0903ab', '0', 'asdw', NULL, NULL);
INSERT INTO `user` VALUES (42, 'laocao', 'asdasdasd', '5722220216@qq.com', '1', 'ACTIVED', '1', '老曹', NULL, NULL);
INSERT INTO `user` VALUES (43, 'why', 'ab123456', '248806223283@qq.com', '1', 'ACTIVED', '1', '汪宏扬', NULL, NULL);
INSERT INTO `user` VALUES (45, 'haha', 'asdasdasd', '232@qq.com', '1', '4b2062b7f64848bd98e8ea1dcbc9a90622a42f2a4f6b4dd989f0dacf9ebb1956', '1', '哈哈', NULL, NULL);
INSERT INTO `user` VALUES (46, 'xiaofang', '11111111', 's', '1', '315f8cc7430c4e01ba76249f510e5c54e10ec7b8551d413c991e3ab33c2efb7d', '1', '小芳', NULL, NULL);
INSERT INTO `user` VALUES (47, 'xiaozhang', 'asdasdasd', '11823237567691@qq.com', '1', '568d5da05df240e5a482bebf46b45b33c20b929aea00422a934290a6b80279c8', '0', '小账', NULL, NULL);
INSERT INTO `user` VALUES (48, 'xiaoliu', 'asdasdasd', '10164sdsd10239@qq.com', '1', '500cd478d067492bb8d8c0e1b3e806abc8fc5a5ad9d341b2adba17867aed1236', '1', '小刘', NULL, NULL);
INSERT INTO `user` VALUES (49, 'xiaowang', 'asdasdasd', '14133904367@qq.com', '1', 'ACTIVED', '1', '小王', NULL, NULL);
INSERT INTO `user` VALUES (50, 'xiaoq', 'asdasdasd', '1016410239@qq.com', '1', 'c10d84f80609424bb548c64ee7dcd3722fd54c369f43459c949c87bc96f1bb0d', '1', '小q', NULL, NULL);
INSERT INTO `user` VALUES (51, 'xiaoz', 'asdasdasd', '141392440444367@qq.com', '1', 'ACTIVED', '1', '小张', NULL, NULL);
INSERT INTO `user` VALUES (52, 'wda', 'asdasdasd', '143313904367@qq.com', '1', '193b9e81a18147ff9e03599c682ada50fd3ea3906d3d48fa830f064b64178b65', '0', '旺达', NULL, NULL);
INSERT INTO `user` VALUES (53, 'ff14', 'asdasdasd', '141392304367@qq.com', '1', 'e0a8a37eaa1d48d69f8e4aa95860aa23a5e1d4e326a54fd7bd396062bff1f8b1', '1', '丰富', NULL, NULL);
INSERT INTO `user` VALUES (55, 'sck', 'asdasdasd', '83722289165@qq.com', '1', '3676da17911645cb844aed3fa03470c202c9361a69ea420b87825fb8a403487a', '0', 'sck', NULL, NULL);
INSERT INTO `user` VALUES (56, 'sjj', 'asdasdasd', '141390224367@qq.com', '1', 'dc20a39bb86c4741ab153eee639aa651a7d536da54ce45cd845d6194c5368178', '0', 'hhq', NULL, NULL);
INSERT INTO `user` VALUES (57, 'qqw', 'asdasdasd', '14139204367@qq.com', '1', '3bd8d82380094fd8b9fadfbaf6a5b033c3d592e42ce7496a986dcd28f966ec04', '0', '实时', NULL, NULL);
INSERT INTO `user` VALUES (58, 'sckk', 'asdasdasd', '837289165@qq.com', '1', '04626d07296049cca3821835ad71023c25b18b10fab94689b44555e9f7c45e3e', '0', 'asd', NULL, NULL);
INSERT INTO `user` VALUES (59, 'qqh', 'asdasdasd', '14139204367@qq.com', '1', '5875f49691e34d72969518da69c8b380039882d310454243848f04690a5374b8', '0', 'asd', NULL, NULL);
INSERT INTO `user` VALUES (63, 'qwe123', 'asdasd123', '11875627691@qq.com', '1', 'ACTIVED', '1', '無雙', NULL, NULL);
INSERT INTO `user` VALUES (65, 'Taoo', 'aaaaaaaa', '9126762583@qq.com', '1', 'ACTIVED', '1', '陶晨博', NULL, NULL);
INSERT INTO `user` VALUES (66, 'qweqweqwe', 'qqqqqqqq', '91267226583@qq.com', '1', 'ACTIVED', '1', 'qweqew', NULL, NULL);
INSERT INTO `user` VALUES (67, 'asd456', 'asdasd123', '118735367691@qq.com', '3', 'ACTIVED', '1', '权威', NULL, NULL);
INSERT INTO `user` VALUES (68, 'zxc123', 'qweqweqwe', '1187567691@qq.com', '1', 'd88f9239543b48089400cd999379e1c1e028d439cfc9410bb2ccace557be8347', '0', '五五', NULL, NULL);
INSERT INTO `user` VALUES (69, 'dfg456', 'qweqweqwe', '11875515616@qq.com', '1', '7223b01736de4530bc96043d2b00f8a4e774110557fd47ba98ff6139cdef52de', '0', '五五', NULL, NULL);
INSERT INTO `user` VALUES (70, 'zxc789', 'zxczxczxc', '118755486@qq.com', '1', '4deb59f7b37b4cd9bbf23406ba0dc1b5b597eea4482a4765967bb1ad7e67fd70', '0', '周舟', NULL, NULL);
INSERT INTO `user` VALUES (71, 'Chosen_one', '123123132', '91262276583@qq.com', '1', 'ACTIVED', '1', '陶晨博', NULL, NULL);
INSERT INTO `user` VALUES (72, 'ABo', 'aaaaaaaaa', '912676583@qq.com', '1', 'ACTIVED', '1', '陶晨博', NULL, NULL);
INSERT INTO `user` VALUES (73, 'whw', 'ab12345678', '110110110@qq.com', '1', '8eb860beccd044b092881cd510e4e917f3f52e446501422cad48832e51e5a60e', '0', '王洪洋', NULL, NULL);
INSERT INTO `user` VALUES (74, 'www', 'ab1234567', '24880622283@qq.com', '1', '32a294255b9c47d69a5f80a4babbeac7154c5f015eaf4d5b843bafbd71fe4701', '0', 'kangkang', NULL, NULL);
INSERT INTO `user` VALUES (75, 'whyy', 'asdasdasd', '2488062283@qq.com', '1', 'ACTIVED', '1', 'wang', NULL, NULL);
INSERT INTO `user` VALUES (76, 'zdsa', 'sa0230))', '57222320216@qq.com', '1', 'd76203a25f7c47d4b047a5335ccb757fd331a783dc424ba2a4505ec763f13e28', '1', 'adasd', NULL, NULL);
INSERT INTO `user` VALUES (77, 'lsk', 'asdasdasd', '1945371948@qq.com', '1', 'cd6afc17e6b24f3195b2ff8f83c6437e4fd3d23dbb1942cabe62e660b71ce80c', '0', '???', '???????6??305', '?????');
INSERT INTO `user` VALUES (78, 'lskasd12', 'asdasdasd', '572220216@qq.com', '1', '37fde44ec5834e3ab195c26cd26fee6931fd211bc51a4f07a5c4780e5da9d118', '0', 'asd', '???????6??305', '?????');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
